American Express (Amex) Record Mappings

The file that you receive from Amex has a distinct layout that identifies header and detail transaction information. There are 13 Amex KR 1025 record mapping layouts:

  • Record 0 Mapping - This mapping details header information for each file.
  • Record 1 Common Mapping - This layout identifies detail information for each expense.  
  • Record 1 Car Rental Mapping - This layout identifies detail information for fields 614 through 819 as they relate to car rental expenses.
  • Record 1 Hotel Mapping - This layout identifies detail information for fields 614 through 819 as they relate to hotel expenses.
  • Record 1 Telephone Mapping - This layout identifies detail information for fields 614 through 819 as they relate to telephone expenses.
  • Record 1 Airline Mapping - This layout identifies detail information for fields 614 through 819 as they relate to airline expenses.
  • Record 1 Retail Mapping - This layout identifies detail information for fields 614 through 819 as they relate to retail expenses.
  • Record 1 Restaurant Mapping - This layout identifies detail information for fields 614 through 819 as they relate to restaurant expenses.
  • Record 1 Rail Mapping - This layout identifies detail information for fields 614 through 819 as they relate to rail expenses.
  • Record 1 Mail Order Mapping - This layout identifies detail information for fields 614 through 819 as they relate to mail order expenses.
  • Record 1 Insurance Mapping - This layout identifies detail information for fields 614 through 819 as they relate to insurance expenses.
  • Record 1 Oil Mapping - This layout identifies detail information for fields 614 through 819 as they relate to oil expenses.
  • Record 1 Event Mapping - This layout identifies detail information for fields 614 through 819 as they relate to event expenses.

Related topics:

  • Amex Record 0 Mapping
    The Amex KR-1025 Record 0 Mapping details header information for each file. The layout of the file contains the following information:
  • Amex Record 1 Common Mapping
    The Amex KR-1025 Record 1 Common file layout identifies detail information for each expense.  Each detail row's layout is the same with the following exceptions:
  • Amex Record 1 Car Rental Mapping
    The Amex KR1025 Record 1 Car Rental Mapping file layout identifies detail information for fields 614 through 819 as they relate to car rental expenses. The file contains the field name, picture information (which describes how long the field is and what type of field it is), the location of the field in the file, the length of each field, and any notes regarding the field.
  • Amex Record 1 Hotel Mapping
    The Amex KR1025 Record 1 Hotel Mapping file layout identifies detail information for fields 614 through 819 as they relate to hotel expenses. The file contains the field name, the picture location, the character location of the field, the length of each field, and any notes regarding the field.
  • Amex Record 1 Telephone Mapping
    The Amex KR1025 Record 1 Telephone Mapping file layout identifies detail information for fields 614 through 819 as they relate to telephone expenses. The file contains the field name, the picture location, the character location of the field, the length of each field, and any notes regarding the field.
  • Amex Record 1 Airline Mapping
    The Amex KR1025 Record 1 Airline Mapping file layout identifies detail information for fields 614 through 819 as they relate to airline expenses. The file contains the field name, the picture location, the character location of the field, the length of each field, and any notes regarding the field.
  • Amex Record 1 Retail Mapping
    The Amex KR1025 Record 1 Retail Mapping file layout identifies detail information for fields 614 through 819 as they relate to retail expenses. The file contains the field name, the picture location, the character location of the field, the length of each field, and any notes regarding the field.
  • Amex Record 1 Restaurant Mapping
    The Amex KR1025 Record 1 Restaurant Mapping file layout identifies detail information for fields 614 through 819 as they relate to restaurant expenses. The file contains the field name, the picture location, the character location of the field, the length of each field, and any notes regarding the field.
  • Amex Record 1 Rail Mapping
    The Amex KR1025 Record 1 Rail Mapping file layout identifies detail information for fields 614 through 819 as they relate to rail expenses. The file contains the field name, the picture location, the character location of the field, the length of each field, and any notes regarding the field.
  • Amex Record 1 Mail Order Mapping
    The Amex KR1025 Record 1 Mail Order Mapping file layout identifies detail information for fields 614 through 819 as they relate to mail order expenses. The file contains the field name, the picture location, the character location of the field, the length of each field, and any notes regarding the field.
  • Amex Record 1 Insurance Mapping
    The Amex KR1025 Record 1 Insurance Mapping file layout identifies detail information for fields 614 through 819 as they relate to insurance expenses. The file contains the field name, the picture location, the character location of the field, the length of each field, and any notes regarding the field.
  • Amex Record 1 Oil Mapping
    The Amex KR1025 Record 1 Oil Mapping file layout identifies detail information for fields 614 through 819 as they relate to oil expenses. The file contains the field name, the picture location, the character location of the field, the length of each field, and any notes regarding the field.
  • Amex Record 1 Event Mapping
    The Amex KR1025 Record 1 Event Mapping file layout identifies detail information for fields 614 through 819 as they relate to event expenses. The file contains the field name, the picture location, the character location of the field, the length of each field, and any notes regarding the field.
Parent Topic: Manage Batch Types Screen